Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 5682 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 532.7 KiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 11 |
|---|
gross_revenue is highly overall correlated with qnty_itens and 3 other fields | High correlation |
recency_days is highly overall correlated with qnty_invoices | High correlation |
qnty_itens is highly overall correlated with gross_revenue and 5 other fields | High correlation |
qnty_invoices is highly overall correlated with gross_revenue and 5 other fields | High correlation |
qnty_products is highly overall correlated with gross_revenue and 4 other fields | High correlation |
avg_recency_days is highly overall correlated with qnty_itens and 2 other fields | High correlation |
frequency is highly overall correlated with qnty_itens and 2 other fields | High correlation |
avg_basket_size is highly overall correlated with gross_revenue and 3 other fields | High correlation |
avg_unique_basket_size is highly overall correlated with qnty_products and 1 other fields | High correlation |
gross_revenue is highly skewed (γ1 = 23.77019547) | Skewed |
qnty_itens is highly skewed (γ1 = 25.79388576) | Skewed |
avg_ticket is highly skewed (γ1 = 23.68750171) | Skewed |
customer_id has unique values | Unique |
avg_recency_days has 2927 (51.5%) zeros | Zeros |
Reproduction
| Analysis started | 2022-12-30 22:18:13.725246 |
|---|---|
| Analysis finished | 2022-12-30 22:18:24.283084 |
| Duration | 10.56 seconds |
| Software version | pandas-profiling vv3.6.1 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 5682 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16605.061 |
| Minimum | 12347 |
|---|---|
| Maximum | 22709 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 12347 |
|---|---|
| 5-th percentile | 12703.05 |
| Q1 | 14292.25 |
| median | 16232.5 |
| Q3 | 18211.75 |
| 95-th percentile | 21742.15 |
| Maximum | 22709 |
| Range | 10362 |
| Interquartile range (IQR) | 3919.5 |
Descriptive statistics
| Standard deviation | 2808.0265 |
|---|---|
| Coefficient of variation (CV) | 0.16910667 |
| Kurtosis | -0.82234601 |
| Mean | 16605.061 |
| Median Absolute Deviation (MAD) | 1959.5 |
| Skewness | 0.44051451 |
| Sum | 94349954 |
| Variance | 7885012.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17850 | 1 | < 0.1% |
| 21128 | 1 | < 0.1% |
| 21110 | 1 | < 0.1% |
| 21109 | 1 | < 0.1% |
| 21108 | 1 | < 0.1% |
| 21107 | 1 | < 0.1% |
| 15007 | 1 | < 0.1% |
| 17899 | 1 | < 0.1% |
| 13833 | 1 | < 0.1% |
| 17312 | 1 | < 0.1% |
| Other values (5672) | 5672 |
| Value | Count | Frequency (%) |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12350 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12354 | 1 | |
| 12355 | 1 | |
| 12356 | 1 | |
| 12357 | 1 |
| Value | Count | Frequency (%) |
| 22709 | 1 | |
| 22708 | 1 | |
| 22707 | 1 | |
| 22706 | 1 | |
| 22705 | 1 | |
| 22704 | 1 | |
| 22700 | 1 | |
| 22699 | 1 | |
| 22696 | 1 | |
| 22695 | 1 |
gross_revenue
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5446 |
|---|---|
| Distinct (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1718.7503 |
| Minimum | 0.42 |
|---|---|
| Maximum | 278713.22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 0.42 |
|---|---|
| 5-th percentile | 12.851 |
| Q1 | 231.6725 |
| median | 602.12 |
| Q3 | 1548.6825 |
| 95-th percentile | 5203.3905 |
| Maximum | 278713.22 |
| Range | 278712.8 |
| Interquartile range (IQR) | 1317.01 |
Descriptive statistics
| Standard deviation | 7371.2013 |
|---|---|
| Coefficient of variation (CV) | 4.2886983 |
| Kurtosis | 740.70723 |
| Mean | 1718.7503 |
| Median Absolute Deviation (MAD) | 470.06 |
| Skewness | 23.770195 |
| Sum | 9765939 |
| Variance | 54334609 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.95 | 9 | 0.2% |
| 7.95 | 9 | 0.2% |
| 2.95 | 8 | 0.1% |
| 1.25 | 8 | 0.1% |
| 12.75 | 7 | 0.1% |
| 3.75 | 7 | 0.1% |
| 7.5 | 7 | 0.1% |
| 1.65 | 7 | 0.1% |
| 5.95 | 6 | 0.1% |
| 4.25 | 6 | 0.1% |
| Other values (5436) | 5608 |
| Value | Count | Frequency (%) |
| 0.42 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 0.79 | 1 | < 0.1% |
| 0.84 | 4 | |
| 0.85 | 3 | 0.1% |
| 1.07 | 1 | < 0.1% |
| 1.25 | 8 | |
| 1.44 | 1 | < 0.1% |
| 1.65 | 7 | |
| 1.69 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278713.22 | 1 | |
| 259657.3 | 1 | |
| 189861.01 | 1 | |
| 135778.1 | 1 | |
| 123645.86 | 1 | |
| 114691.21 | 1 | |
| 88462.04 | 1 | |
| 65920.12 | 1 | |
| 63031.62 | 1 | |
| 61255.04 | 1 |
recency_days
Real number (ℝ)
| Distinct | 304 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 117.30077 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 37 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 23 |
| median | 71 |
| Q3 | 200 |
| 95-th percentile | 338 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 177 |
Descriptive statistics
| Standard deviation | 111.77505 |
|---|---|
| Coefficient of variation (CV) | 0.95289272 |
| Kurtosis | -0.65445903 |
| Mean | 117.30077 |
| Median Absolute Deviation (MAD) | 61.5 |
| Skewness | 0.80789939 |
| Sum | 666503 |
| Variance | 12493.663 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 110 | 1.9% |
| 4 | 105 | 1.8% |
| 3 | 96 | 1.7% |
| 2 | 90 | 1.6% |
| 10 | 88 | 1.5% |
| 8 | 83 | 1.5% |
| 17 | 79 | 1.4% |
| 9 | 79 | 1.4% |
| 7 | 76 | 1.3% |
| 15 | 66 | 1.2% |
| Other values (294) | 4810 |
| Value | Count | Frequency (%) |
| 0 | 37 | 0.7% |
| 1 | 110 | |
| 2 | 90 | |
| 3 | 96 | |
| 4 | 105 | |
| 5 | 52 | |
| 7 | 76 | |
| 8 | 83 | |
| 9 | 79 | |
| 10 | 88 |
| Value | Count | Frequency (%) |
| 373 | 24 | |
| 372 | 22 | |
| 371 | 17 | |
| 369 | 4 | 0.1% |
| 368 | 13 | |
| 367 | 16 | |
| 366 | 15 | |
| 365 | 20 | |
| 364 | 11 | |
| 362 | 7 | 0.1% |
qnty_itens
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 1822 |
|---|---|
| Distinct (%) | 32.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 933.69095 |
| Minimum | 1 |
|---|---|
| Maximum | 196556 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 104 |
| median | 314 |
| Q3 | 794.75 |
| 95-th percentile | 2852.8 |
| Maximum | 196556 |
| Range | 196555 |
| Interquartile range (IQR) | 690.75 |
Descriptive statistics
| Standard deviation | 4124.5222 |
|---|---|
| Coefficient of variation (CV) | 4.4174383 |
| Kurtosis | 992.1513 |
| Mean | 933.69095 |
| Median Absolute Deviation (MAD) | 251 |
| Skewness | 25.793886 |
| Sum | 5305232 |
| Variance | 17011683 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 115 | 2.0% |
| 2 | 72 | 1.3% |
| 3 | 50 | 0.9% |
| 4 | 49 | 0.9% |
| 5 | 35 | 0.6% |
| 6 | 29 | 0.5% |
| 12 | 24 | 0.4% |
| 72 | 23 | 0.4% |
| 88 | 23 | 0.4% |
| 7 | 21 | 0.4% |
| Other values (1812) | 5241 |
| Value | Count | Frequency (%) |
| 1 | 115 | |
| 2 | 72 | |
| 3 | 50 | |
| 4 | 49 | |
| 5 | 35 | 0.6% |
| 6 | 29 | 0.5% |
| 7 | 21 | 0.4% |
| 8 | 17 | 0.3% |
| 9 | 7 | 0.1% |
| 10 | 17 | 0.3% |
| Value | Count | Frequency (%) |
| 196556 | 1 | |
| 77209 | 1 | |
| 76946 | 1 | |
| 69021 | 1 | |
| 64124 | 1 | |
| 63033 | 1 | |
| 61872 | 1 | |
| 57961 | 1 | |
| 57010 | 1 | |
| 49391 | 1 |
qnty_invoices
Real number (ℝ)
| Distinct | 55 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4167547 |
| Minimum | 1 |
|---|---|
| Maximum | 202 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 11 |
| Maximum | 202 |
| Range | 201 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 6.596809 |
|---|---|
| Coefficient of variation (CV) | 1.9307236 |
| Kurtosis | 304.25869 |
| Mean | 3.4167547 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.182002 |
| Sum | 19414 |
| Variance | 43.517889 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2874 | |
| 2 | 830 | 14.6% |
| 3 | 502 | 8.8% |
| 4 | 394 | 6.9% |
| 5 | 231 | 4.1% |
| 6 | 178 | 3.1% |
| 7 | 136 | 2.4% |
| 8 | 97 | 1.7% |
| 9 | 67 | 1.2% |
| 11 | 52 | 0.9% |
| Other values (45) | 321 | 5.6% |
| Value | Count | Frequency (%) |
| 1 | 2874 | |
| 2 | 830 | 14.6% |
| 3 | 502 | 8.8% |
| 4 | 394 | 6.9% |
| 5 | 231 | 4.1% |
| 6 | 178 | 3.1% |
| 7 | 136 | 2.4% |
| 8 | 97 | 1.7% |
| 9 | 67 | 1.2% |
| 10 | 51 | 0.9% |
| Value | Count | Frequency (%) |
| 202 | 1 | |
| 191 | 1 | |
| 120 | 1 | |
| 90 | 2 | |
| 87 | 1 | |
| 85 | 1 | |
| 71 | 1 | |
| 61 | 1 | |
| 60 | 1 | |
| 55 | 1 |
qnty_products
Real number (ℝ)
| Distinct | 521 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.67969 |
| Minimum | 1 |
|---|---|
| Maximum | 6307 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 14 |
| median | 40 |
| Q3 | 103 |
| 95-th percentile | 319.95 |
| Maximum | 6307 |
| Range | 6306 |
| Interquartile range (IQR) | 89 |
Descriptive statistics
| Standard deviation | 191.4163 |
|---|---|
| Coefficient of variation (CV) | 2.1344442 |
| Kurtosis | 382.88242 |
| Mean | 89.67969 |
| Median Absolute Deviation (MAD) | 32 |
| Skewness | 15.177168 |
| Sum | 509560 |
| Variance | 36640.198 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 261 | 4.6% |
| 2 | 150 | 2.6% |
| 3 | 107 | 1.9% |
| 6 | 99 | 1.7% |
| 10 | 95 | 1.7% |
| 4 | 91 | 1.6% |
| 9 | 90 | 1.6% |
| 5 | 88 | 1.5% |
| 7 | 87 | 1.5% |
| 8 | 84 | 1.5% |
| Other values (511) | 4530 |
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 2 | 150 | |
| 3 | 107 | |
| 4 | 91 | 1.6% |
| 5 | 88 | 1.5% |
| 6 | 99 | 1.7% |
| 7 | 87 | 1.5% |
| 8 | 84 | 1.5% |
| 9 | 90 | 1.6% |
| 10 | 95 | 1.7% |
| Value | Count | Frequency (%) |
| 6307 | 1 | |
| 5095 | 1 | |
| 4563 | 1 | |
| 4295 | 1 | |
| 2441 | 1 | |
| 2051 | 1 | |
| 2036 | 1 | |
| 1723 | 1 | |
| 1662 | 1 | |
| 1634 | 1 |
avg_ticket
Real number (ℝ)
| Distinct | 5490 |
|---|---|
| Distinct (%) | 96.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.491036 |
| Minimum | 0.42 |
|---|---|
| Maximum | 4288.0667 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 0.42 |
|---|---|
| 5-th percentile | 3.5083935 |
| Q1 | 7.95 |
| median | 15.765078 |
| Q3 | 22.106067 |
| 95-th percentile | 76.32 |
| Maximum | 4288.0667 |
| Range | 4287.6467 |
| Interquartile range (IQR) | 14.156067 |
Descriptive statistics
| Standard deviation | 116.20947 |
|---|---|
| Coefficient of variation (CV) | 3.9405014 |
| Kurtosis | 723.30041 |
| Mean | 29.491036 |
| Median Absolute Deviation (MAD) | 7.4804101 |
| Skewness | 23.687502 |
| Sum | 167568.07 |
| Variance | 13504.64 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.75 | 11 | 0.2% |
| 4.95 | 10 | 0.2% |
| 1.25 | 9 | 0.2% |
| 2.95 | 9 | 0.2% |
| 7.95 | 8 | 0.1% |
| 12.75 | 7 | 0.1% |
| 1.65 | 7 | 0.1% |
| 8.25 | 7 | 0.1% |
| 15 | 6 | 0.1% |
| 4.15 | 6 | 0.1% |
| Other values (5480) | 5602 |
| Value | Count | Frequency (%) |
| 0.42 | 3 | |
| 0.535 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 0.79 | 1 | < 0.1% |
| 0.8371428571 | 1 | < 0.1% |
| 0.84 | 2 | |
| 0.85 | 3 | |
| 1.002222222 | 1 | < 0.1% |
| 1.02 | 1 | < 0.1% |
| 1.045 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4288.066667 | 1 | |
| 3861 | 1 | |
| 3202.92 | 1 | |
| 3096 | 1 | |
| 1687.2 | 1 | |
| 1377.077778 | 1 | |
| 1001.2 | 1 | |
| 967.5589091 | 1 | |
| 931.5 | 1 | |
| 910.6735714 | 1 |
avg_recency_days
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 1159 |
|---|---|
| Distinct (%) | 20.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.497378 |
| Minimum | 0 |
|---|---|
| Maximum | 366 |
| Zeros | 2927 |
| Zeros (%) | 51.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 58 |
| 95-th percentile | 166 |
| Maximum | 366 |
| Range | 366 |
| Interquartile range (IQR) | 58 |
Descriptive statistics
| Standard deviation | 61.011957 |
|---|---|
| Coefficient of variation (CV) | 1.5848341 |
| Kurtosis | 6.3549791 |
| Mean | 38.497378 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.3211218 |
| Sum | 218742.1 |
| Variance | 3722.4589 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2927 | |
| 70 | 22 | 0.4% |
| 46 | 17 | 0.3% |
| 55 | 17 | 0.3% |
| 42 | 16 | 0.3% |
| 31 | 16 | 0.3% |
| 28 | 15 | 0.3% |
| 21 | 15 | 0.3% |
| 49 | 15 | 0.3% |
| 56 | 14 | 0.2% |
| Other values (1149) | 2608 |
| Value | Count | Frequency (%) |
| 0 | 2927 | |
| 1 | 9 | 0.2% |
| 2 | 4 | 0.1% |
| 2.929133858 | 1 | < 0.1% |
| 3 | 5 | 0.1% |
| 3.351351351 | 1 | < 0.1% |
| 3.36036036 | 1 | < 0.1% |
| 4 | 4 | 0.1% |
| 4.191011236 | 1 | < 0.1% |
| 4.275862069 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 366 | 1 | < 0.1% |
| 365 | 1 | < 0.1% |
| 364 | 1 | < 0.1% |
| 363 | 1 | < 0.1% |
| 357 | 2 | |
| 356 | 1 | < 0.1% |
| 355 | 2 | |
| 352 | 1 | < 0.1% |
| 351 | 2 | |
| 350 | 3 |
frequency
Real number (ℝ)
| Distinct | 1204 |
|---|---|
| Distinct (%) | 21.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.54904729 |
| Minimum | 0.0054495913 |
|---|---|
| Maximum | 17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 0.0054495913 |
|---|---|
| 5-th percentile | 0.010989011 |
| Q1 | 0.024793388 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 17 |
| Range | 16.99455 |
| Interquartile range (IQR) | 0.97520661 |
Descriptive statistics
| Standard deviation | 0.55056542 |
|---|---|
| Coefficient of variation (CV) | 1.002765 |
| Kurtosis | 139.03774 |
| Mean | 0.54904729 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.8477436 |
| Sum | 3119.6867 |
| Variance | 0.30312229 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2882 | |
| 2 | 50 | 0.9% |
| 0.02777777778 | 18 | 0.3% |
| 0.0625 | 17 | 0.3% |
| 0.02380952381 | 16 | 0.3% |
| 0.09090909091 | 15 | 0.3% |
| 0.02941176471 | 15 | 0.3% |
| 0.02127659574 | 13 | 0.2% |
| 0.01923076923 | 13 | 0.2% |
| 0.07692307692 | 13 | 0.2% |
| Other values (1194) | 2630 |
| Value | Count | Frequency (%) |
| 0.005449591281 | 1 | < 0.1% |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005494505495 | 1 | < 0.1% |
| 0.005586592179 | 2 | |
| 0.005602240896 | 1 | < 0.1% |
| 0.005617977528 | 2 | |
| 0.00566572238 | 1 | < 0.1% |
| 0.005681818182 | 2 | |
| 0.005698005698 | 3 |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 4 | 0.1% |
| 2 | 50 | 0.9% |
| 1.142857143 | 1 | < 0.1% |
| 1 | 2882 | |
| 0.6666666667 | 3 | 0.1% |
| 0.5401069519 | 1 | < 0.1% |
| 0.5120643432 | 1 | < 0.1% |
| 0.5 | 3 | 0.1% |
avg_basket_size
Real number (ℝ)
| Distinct | 2361 |
|---|---|
| Distinct (%) | 41.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 246.7422 |
| Minimum | 1 |
|---|---|
| Maximum | 14149 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 73.6875 |
| median | 150 |
| Q3 | 288 |
| 95-th percentile | 731.95 |
| Maximum | 14149 |
| Range | 14148 |
| Interquartile range (IQR) | 214.3125 |
Descriptive statistics
| Standard deviation | 436.04325 |
|---|---|
| Coefficient of variation (CV) | 1.7672017 |
| Kurtosis | 387.40303 |
| Mean | 246.7422 |
| Median Absolute Deviation (MAD) | 96 |
| Skewness | 14.667628 |
| Sum | 1401989.2 |
| Variance | 190133.71 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 116 | 2.0% |
| 2 | 71 | 1.2% |
| 3 | 50 | 0.9% |
| 4 | 49 | 0.9% |
| 5 | 35 | 0.6% |
| 6 | 30 | 0.5% |
| 72 | 25 | 0.4% |
| 12 | 25 | 0.4% |
| 88 | 21 | 0.4% |
| 7 | 21 | 0.4% |
| Other values (2351) | 5239 |
| Value | Count | Frequency (%) |
| 1 | 116 | |
| 2 | 71 | |
| 3 | 50 | |
| 3.333333333 | 1 | < 0.1% |
| 4 | 49 | |
| 5 | 35 | 0.6% |
| 5.666666667 | 1 | < 0.1% |
| 6 | 30 | 0.5% |
| 7 | 21 | 0.4% |
| 7.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 14149 | 1 | |
| 13956 | 1 | |
| 7824 | 1 | |
| 5963 | 1 | |
| 5197 | 1 | |
| 4300 | 1 | |
| 4280 | 1 | |
| 4278 | 1 | |
| 4136 | 1 | |
| 4049.789474 | 1 |
avg_unique_basket_size
Real number (ℝ)
| Distinct | 1244 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.660301 |
| Minimum | 1 |
|---|---|
| Maximum | 1113 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 88.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.3333333 |
| Q1 | 8.6666667 |
| median | 17.666667 |
| Q3 | 35 |
| 95-th percentile | 174.95 |
| Maximum | 1113 |
| Range | 1112 |
| Interquartile range (IQR) | 26.333333 |
Descriptive statistics
| Standard deviation | 77.008201 |
|---|---|
| Coefficient of variation (CV) | 1.9416948 |
| Kurtosis | 32.433521 |
| Mean | 39.660301 |
| Median Absolute Deviation (MAD) | 11.3125 |
| Skewness | 5.012874 |
| Sum | 225349.83 |
| Variance | 5930.263 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 283 | 5.0% |
| 2 | 165 | 2.9% |
| 3 | 111 | 2.0% |
| 10 | 107 | 1.9% |
| 6 | 99 | 1.7% |
| 9 | 99 | 1.7% |
| 13 | 96 | 1.7% |
| 7 | 93 | 1.6% |
| 5 | 92 | 1.6% |
| 4 | 91 | 1.6% |
| Other values (1234) | 4446 |
| Value | Count | Frequency (%) |
| 1 | 283 | |
| 1.2 | 1 | < 0.1% |
| 1.333333333 | 2 | < 0.1% |
| 1.5 | 8 | 0.1% |
| 1.527777778 | 1 | < 0.1% |
| 1.666666667 | 5 | 0.1% |
| 1.8 | 1 | < 0.1% |
| 1.833333333 | 1 | < 0.1% |
| 1.888888889 | 1 | < 0.1% |
| 2 | 165 |
| Value | Count | Frequency (%) |
| 1113 | 1 | |
| 748 | 1 | |
| 730 | 1 | |
| 720 | 1 | |
| 704 | 1 | |
| 686 | 1 | |
| 675 | 1 | |
| 674 | 1 | |
| 661 | 1 | |
| 649 | 1 |
| customer_id | gross_revenue | recency_days | qnty_itens | qnty_invoices | qnty_products | avg_ticket | avg_recency_days | frequency | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.177 | 0.244 | -0.289 | -0.383 | -0.045 | -0.387 | -0.387 | 0.381 | -0.146 | 0.115 |
| gross_revenue | -0.177 | 1.000 | -0.424 | 0.929 | 0.641 | 0.836 | 0.349 | 0.436 | -0.452 | 0.728 | 0.488 |
| recency_days | 0.244 | -0.424 | 1.000 | -0.495 | -0.597 | -0.376 | -0.150 | -0.472 | 0.487 | -0.199 | -0.036 |
| qnty_itens | -0.289 | 0.929 | -0.495 | 1.000 | 0.693 | 0.779 | 0.336 | 0.501 | -0.513 | 0.793 | 0.410 |
| qnty_invoices | -0.383 | 0.641 | -0.597 | 0.693 | 1.000 | 0.530 | 0.270 | 0.799 | -0.800 | 0.161 | -0.049 |
| qnty_products | -0.045 | 0.836 | -0.376 | 0.779 | 0.530 | 1.000 | -0.136 | 0.345 | -0.359 | 0.613 | 0.768 |
| avg_ticket | -0.387 | 0.349 | -0.150 | 0.336 | 0.270 | -0.136 | 1.000 | 0.230 | -0.228 | 0.272 | -0.352 |
| avg_recency_days | -0.387 | 0.436 | -0.472 | 0.501 | 0.799 | 0.345 | 0.230 | 1.000 | -0.987 | 0.126 | -0.036 |
| frequency | 0.381 | -0.452 | 0.487 | -0.513 | -0.800 | -0.359 | -0.228 | -0.987 | 1.000 | -0.130 | 0.031 |
| avg_basket_size | -0.146 | 0.728 | -0.199 | 0.793 | 0.161 | 0.613 | 0.272 | 0.126 | -0.130 | 1.000 | 0.606 |
| avg_unique_basket_size | 0.115 | 0.488 | -0.036 | 0.410 | -0.049 | 0.768 | -0.352 | -0.036 | 0.031 | 0.606 | 1.000 |
| customer_id | gross_revenue | recency_days | qnty_itens | qnty_invoices | qnty_products | avg_ticket | avg_recency_days | frequency | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850 | 5298.79 | 372 | 1698 | 34 | 210 | 25.232333 | 1.000000 | 17.000000 | 49.941176 | 6.176471 |
| 1 | 13047 | 3089.10 | 56 | 1355 | 9 | 149 | 20.732215 | 52.833333 | 0.028302 | 150.555556 | 16.555556 |
| 2 | 12583 | 6629.34 | 2 | 4978 | 15 | 227 | 29.204141 | 26.500000 | 0.040323 | 331.866667 | 15.133333 |
| 3 | 13748 | 948.25 | 95 | 439 | 5 | 28 | 33.866071 | 92.666667 | 0.017921 | 87.800000 | 5.600000 |
| 4 | 15291 | 4564.60 | 25 | 2094 | 14 | 94 | 48.559574 | 26.769231 | 0.040115 | 149.571429 | 6.714286 |
| 5 | 14688 | 5155.03 | 7 | 3188 | 20 | 265 | 19.452943 | 19.263158 | 0.054496 | 159.400000 | 13.250000 |
| 6 | 17809 | 5344.66 | 16 | 2016 | 11 | 59 | 90.587458 | 39.666667 | 0.030726 | 183.272727 | 5.363636 |
| 7 | 15311 | 61255.04 | 0 | 37693 | 90 | 2036 | 30.085972 | 4.191011 | 0.240642 | 418.811111 | 22.622222 |
| 8 | 16098 | 2005.63 | 87 | 613 | 7 | 67 | 29.934776 | 47.666667 | 0.024390 | 87.571429 | 9.571429 |
| 9 | 18074 | 489.60 | 373 | 190 | 1 | 13 | 37.661538 | 0.000000 | 1.000000 | 190.000000 | 13.000000 |
| customer_id | gross_revenue | recency_days | qnty_itens | qnty_invoices | qnty_products | avg_ticket | avg_recency_days | frequency | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5672 | 16716 | 336.60 | 311 | 44 | 1 | 1 | 336.600000 | 0.0 | 1.000000 | 44.0 | 1.0 |
| 5673 | 16073 | 94.35 | 297 | 37 | 1 | 1 | 94.350000 | 0.0 | 1.000000 | 37.0 | 1.0 |
| 5674 | 17440 | 177.10 | 247 | 232 | 2 | 3 | 59.033333 | 0.0 | 2.000000 | 116.0 | 1.5 |
| 5675 | 18220 | 298.92 | 226 | 282 | 1 | 2 | 149.460000 | 0.0 | 1.000000 | 282.0 | 2.0 |
| 5676 | 16998 | 277.50 | 304 | 74 | 1 | 1 | 277.500000 | 0.0 | 1.000000 | 74.0 | 1.0 |
| 5677 | 15098 | 301.95 | 182 | 61 | 1 | 1 | 301.950000 | 0.0 | 1.000000 | 61.0 | 1.0 |
| 5678 | 13217 | 126.42 | 131 | 114 | 2 | 2 | 63.210000 | 25.0 | 0.076923 | 57.0 | 1.0 |
| 5679 | 13106 | 59.50 | 133 | 14 | 1 | 1 | 59.500000 | 0.0 | 1.000000 | 14.0 | 1.0 |
| 5680 | 17747 | 65.45 | 112 | 11 | 1 | 1 | 65.450000 | 0.0 | 1.000000 | 11.0 | 1.0 |
| 5681 | 16462 | 102.00 | 283 | 12 | 1 | 1 | 102.000000 | 0.0 | 1.000000 | 12.0 | 1.0 |